<%@page import="com.zhuoshi.bean.CustomerBean"%>
<%@page import="com.zhuoshi.dao.CustomerDao"%>
<%@page import="com.zhuoshi.bean.ManagerBean"%>
<%@page import="com.zhuoshi.dao.ManagerDao"%>
<%@page import="com.zhuoshi.bean.ManagerRoleBean"%>
<%@page import="com.zhuoshi.dao.ManagerRoleDao"%>
<%@page import="com.zhuoshi.bean.ProvinceBean"%>
<%@page import="com.zhuoshi.dao.ProvinceDao"%>
<%@page import="com.zhuoshi.bean.AreaBean"%>
<%@page import="com.zhuoshi.dao.AreaDao"%>
<%@page import="com.zhuoshi.bean.ContractMasterBean"%>
<%@page import="com.zhuoshi.dao.ContractMasterDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";

	//绑定基本数据
	ContractMasterDao dao = new ContractMasterDao();
	List<ContractMasterBean> list = dao.getAllList();
	pageContext.setAttribute("list", list);

	//绑定客户
	CustomerDao customerDao = new CustomerDao();
	List<CustomerBean> customerList = customerDao.getAllList();
	pageContext.setAttribute("customerList", customerList);

	//绑定区域 area
	AreaDao areaDao = new AreaDao();
	List<AreaBean> areaList = areaDao.getList();
	pageContext.setAttribute("areaList", areaList);
	//绑定省份province
	ProvinceDao provinceDao = new ProvinceDao();
	List<ProvinceBean> provinceList = provinceDao.getList();
	pageContext.setAttribute("provinceList", provinceList);
	//绑定项目经理  role_id=4
	ManagerDao roleDao = new ManagerDao();
	ManagerBean managerBean = new ManagerBean();
	managerBean.setRole_id(4);
	List<ManagerBean> managerList = roleDao.getList(managerBean);
	pageContext.setAttribute("managerList", managerList);
%>

<!DOCTYPE html>
<!-- saved from url=(0045)http://localhost:8080/EMIS/getallcontractinfo -->
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<meta name="renderer" content="webkit|ie-comp|ie-stand">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no">
<meta http-equiv="Cache-Control" content="no-siteapp">
<!--[if lt IE 9]>
<script type="text/javascript" src="lib/html5.js"></script>
<script type="text/javascript" src="lib/respond.min.js"></script>
<script type="text/javascript" src="lib/PIE_IE678.js"></script>
<![endif]-->
<link rel="stylesheet" type="text/css" href="template/H-ui.min.css">
<link rel="stylesheet" type="text/css" href="template/H-ui.admin.css">
<link rel="stylesheet" type="text/css" href="template/iconfont.css">
<link rel="stylesheet" type="text/css" href="template/icheck.css">
<link rel="stylesheet" type="text/css" href="template/skin.css" id="skin">
<link rel="stylesheet" type="text/css" href="template/style.css">
<!--[if IE 6]>
<script type="text/javascript" src="http://lib.h-ui.net/DD_belatedPNG_0.0.8a-min.js" ></script>
<script>DD_belatedPNG.fix('*');</script>
<![endif]-->
<title>合同基本信息管理</title>
<link rel="stylesheet" href="template/layer.css" id="layui_layer_skinlayercss">
<link href="template/WdatePicker.css" rel="stylesheet" type="text/css"></head>

<body>
<nav class="breadcrumb"><i class="Hui-iconfont"></i> 首页 <span class="c-gray en">&gt;</span> 系统管理 <span class="c-gray en">&gt;</span>合同基本信息管理</nav>
<div class="page-container">
<form action="http://localhost:8080/EMIS/coninfosearchbykeyword" method="post">
	<div class="text-c"> 日期范围：
		<input type="text" name="start" onFocus="WdatePicker({maxDate:&#39;#F{$dp.$D(\&#39;datemax\&#39;)||\&#39;%y-%M-%d\&#39;}&#39;})" id="datemin" class="input-text Wdate" style="width:120px;">
		-
		<input type="text" name="end" onFocus="WdatePicker({minDate:&#39;#F{$dp.$D(\&#39;datemin\&#39;)}&#39;,maxDate:&#39;%y-%M-%d&#39;})" id="datemax" class="input-text Wdate" style="width:120px;">&nbsp;
		<input type="text" class="input-text" style="width:100px" placeholder="合同数字编号" id="" name="contractnum">&nbsp;
		<input type="text" class="input-text" style="width:100px" placeholder="区域" id="" name="area">&nbsp;
		<input type="text" class="input-text" style="width:100px" placeholder="省份" id="" name="province">&nbsp;
		<button type="submit" class="btn btn-success radius" id="" name=""><i class="Hui-iconfont"></i> 搜销售合同</button>
	</div>
</form>
    
	<div class="cl pd-5 bg-1 bk-gray mt-20"> 
	<span class="l">  <a class="btn btn-primary radius" onClick="system_category_add(&#39;添加合同基本信息&#39;,&#39;contractmaster_add.jsp&#39;)" href="javascript:;"><i class="Hui-iconfont"></i> 添加合同基本信息</a></span>
	</div>
	
	<div class="mt-20">
	
		<div id="DataTables_Table_0_wrapper" class="dataTables_wrapper no-footer">
		  <table class="table table-border table-bordered table-hover table-bg table-sort dataTable no-footer" id="DataTables_Table_0" role="grid" aria-describedby="DataTables_Table_0_info">
			<thead>
				<tr class="text-c" role="row">
				<th class="sorting_disabled" rowspan="1" colspan="1" aria-label="合同字母编号" style="width: 71px;">合同字母编号</th>
				<th class="sorting_desc" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-sort="descending" aria-label="合同数字编号: 升序排列" style="width: 71px;">合同数字编号</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="销售单号: 升序排列" style="width: 58px;">销售单号</th>
				<th class="sorting_disabled" rowspan="1" colspan="1" aria-label="采购方" style="width: 35px;">采购方</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="客户: 升序排列" style="width: 157px;">客户</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="合同签订日期: 升序排列" style="width: 72px;">合同签订日期</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="项目经理: 升序排列" style="width: 48px;">项目经理</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="区域: 升序排列" style="width: 23px;">区域</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="省份: 升序排列" style="width: 23px;">省份</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="操作: 升序排列" style="width: 34px;">操作</th>
				<th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" aria-label="合同明细: 升序排列" style="width: 54px;">合同明细</th>
				
				</tr>
			</thead>
          <tbody>               
          
                   
          
                   
          
                   
           	<c:forEach items="${list }" var="cBean">
           	
           	
		  <tr class="text-c odd" role="row">
					<td>${cBean.letternum }</td>
					<td class="sorting_1">${cBean.numerical }</td>
					<td>${cBean.saleno }</td>
				    <td>${cBean.purch }</td>
					<td>
									<c:forEach items="${customerList }" var="customerBean">
										<c:if test="${customerBean.id == cBean.customerid }">
                            ${customerBean.constracts }
                            </c:if>
									</c:forEach>

								
					</td>
					<td>${cBean.condate }</td>
					<td>
					<c:forEach items="${managerList }" var="managerBean">
										<c:if test="${managerBean.id == cBean.managerid }">
                            ${managerBean.realname }
                            </c:if>
									</c:forEach>
					
					
					</td>
					<td>
					
					<c:forEach items="${areaList }" var="areaBean">
                            <c:if test="${areaBean.id == cBean.area }">
                            ${areaBean.areaname }
                            </c:if>
                            </c:forEach>
					</td>
					<td>
					<c:forEach items="${provinceList }" var="provinceBean">
                     <c:if test="${provinceBean.id == cBean.province }">
                      ${provinceBean.province }
                       </c:if>
                     </c:forEach>

					</td>
					<td class="f-14">
					
					  <a title="编辑" href="javascript:;" onClick="system_category_edit(&#39;修改合同基本信息&#39;,&#39;contractmaster_update.jsp?id=${cBean.id}&#39;,&#39;1&#39;,&#39;800&#39;,&#39;480&#39;)" style="text-decoration:none"><i class="Hui-iconfont"></i></a>
					
					  <a title="删除" href="contractmaster_del.jsp?id=${cBean.id}" class="ml-5" style="text-decoration:none"><i class="Hui-iconfont"></i></a>
		    </td>
					<td><form action="contractsublist.jsp?numerical=${cBean.numerical }" method="post" id="form">
					     <input type="text" class="input-text" hidden="hidden" value="${cBean.numerical }" name="contractnum">
					     <input type="submit" class="btn btn-primary radius" name="jinru" value="进入">
					    </form>
					</td>
		    </tr>
</c:forEach>
				   
				   
					
					
					
				   
				   
				   
				   
				   </tbody>
		</table>
		</div>
	</div>
</div>
	<footer class="footer mt-20">
	<div class="container">
		Copyright ©       本后台系统由KEG提供技术支持
	</div>
    </footer>
<script type="text/javascript" src="template/jquery.min.js"></script> 
<script type="text/javascript" src="template/layer.js"></script>
<script type="text/javascript" src="template/laypage.js"></script> 
<script type="text/javascript" src="template/WdatePicker.js"></script> 
<script type="text/javascript" src="template/jquery.dataTables.min.js"></script> 
<script type="text/javascript" src="template/H-ui.js"></script><a href="javascript:void(0)" class="Hui-iconfont toTop" title="返回顶部" alt="返回顶部" style="display:none"></a> 
<script type="text/javascript" src="template/H-ui.admin.js"></script> 
<script type="text/javascript">
$('.table-sort').dataTable({
	"aaSorting": [[ 1, "desc" ]],//默认第几个排序
	"bStateSave": true,//状态保存
	"aoColumnDefs": [
	  //{"bVisible": false, "aTargets": [ 3 ]} //控制列的隐藏显示
	  {"orderable":false,"aTargets":[0,4]}// 制定列不参与排序
	]
});
/*系统-栏目-添加*/
function system_category_add(title,url,w,h){
	layer_show(title,url,w,h);
}
/*系统-栏目-编辑*/
function system_category_edit(title,url,id,w,h){
	layer_show(title,url,w,h);
}
/*系统-栏目-删除*/
function system_category_del(title,url,id,w,h){
	layer_show(title,url,w,h);

}
</script>

</body></html>